SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536682 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536682 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513290,321024,280096,945141,1340,429965,791571,850739,289050,283875,457566,71297,882452,284980,238327,884498,354859,683223,121290,295235,468490,226322,849282,5080,823900,745349,809782,837594,863717,642523,732997,597317,180078,207125,955603,580878,11119,716288,101913,842206,464112,656781,211173,963024,184953,9298,18397,576442,491897,58858,453258,945202,421250,833754,564323,777272,425857,831197,820622,392930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]