SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648201 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648201 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524556,90230,255389,132841,464553,666090,716400,715397,958460,699742,616303,260006,199697,1002435,926041,639038,36505,85451,247783,468224,810031,17567,390444,200903,291947,588196,216578,547278,843503,522569,318561,69490,197312,368845,915042,632280,553539,856034,51613,262024,36131,479004,160196,863007,781053,756388,957739,118714,30764,61037,628713,332175,550087,777905,962360,1019763,355652,179678,533421,111608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]