SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106986 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106986 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96592,205894,899990,350041,158414,963682,29977,964025,252738,1000216,966469,277183,2927,261191,381576,579312,600349,778832,168027,970324,795832,112868,689768,615622,82017,607906,616027,464099,913481,727904,921748,24138,731170,205157,107917,430455,1034090,546980,360944,1008834,433395,352007,297282,252449,126087,182878,696469,925520,352130,282687,541544,542500,622227,203970,49173,212898,336255,408310,848560,49156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]