SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507076 LIMIT 1 [ RunTime:0.001078s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507076 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141940,742094,992027,673893,205158,80636,160317,773759,873211,903068,789105,342441,572958,947927,258079,673764,345777,981733,662953,513673,829876,849648,865179,921469,783318,879001,687089,1047241,575267,965435,966991,354302,217093,986996,307411,84980,246074,836944,523186,444452,665111,13606,919710,364811,433906,931633,274945,421138,436883,885014,141871,354494,682483,715811,951348,192953,585584,846866,956482,830418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.041935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003629s ]