SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535611 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535611 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311787,993076,413732,101214,199523,64625,899730,755715,433332,225667,375573,598239,225817,639083,559913,197830,566724,314545,231071,395070,1025390,883122,342437,116543,21276,532519,178832,292917,795757,429607,706942,153667,837466,96291,164603,914027,418193,572582,781605,21286,798871,638903,660416,1016601,26484,132074,391773,549806,746227,11466,319410,667310,877292,570579,501399,910438,586820,890678,606180,349571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]