SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546000 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546000 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321154,1043096,955532,612654,291025,684249,1043101,974312,840087,713223,682205,408426,658874,527869,857488,900125,246801,462178,165311,612325,539247,84634,152020,395072,264292,964996,910851,961676,757167,457810,211397,78998,795220,49485,333996,648399,610123,250150,562279,463209,625974,594656,707941,919391,595909,675507,564026,165035,262224,370077,429248,991709,925394,247066,641876,692894,5186,455351,61917,528968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]