SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180211 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180211 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478324,603395,359977,475667,8264,255800,109682,425579,762771,935441,813376,998570,771896,930184,202522,61582,592023,146787,207743,742412,1015940,717680,570264,805164,406617,324076,33141,387342,716669,852343,117519,237301,123061,972410,799102,1033574,267904,585820,850285,420633,377119,87662,224300,721611,742907,835711,578413,57426,456262,760606,810930,139384,644395,497975,748217,554814,780631,621592,984164,903617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003182s ]