SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410501 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410501 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212684,574351,264960,818671,938583,240604,1026890,875515,868994,331861,454264,361007,879157,347490,50283,89499,971253,648053,399560,1015078,689884,931229,419846,199498,337369,936576,281570,989650,641717,314012,495063,161836,1005649,818248,178076,76304,382754,1002172,947904,289137,379318,906510,651260,1047798,291098,174319,955199,68891,730187,934392,436460,761842,826692,195905,489599,222868,170806,875199,367941,241117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]