SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532003 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532003 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722541,618535,121366,978015,30341,613349,982821,434383,937115,945991,921784,935177,468981,926945,81105,159270,1032208,866398,258948,396505,259400,643307,718243,440590,925252,237913,777533,658748,835640,117491,225234,722436,139828,446742,957563,533552,512808,35380,159491,1033708,717938,1035358,467801,924571,968001,159970,958111,27130,486620,427505,804578,129819,1007828,1003847,722959,660778,105276,1026088,943614,5083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]