SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036007 LIMIT 1 [ RunTime:0.001998s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036007 [ RunTime:0.003943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749032,240352,690846,423312,145479,632482,711072,334122,634166,839428,921384,52242,63651,312215,499866,292249,436433,442217,40616,566007,984122,975489,885111,259785,890288,82609,76929,16634,111042,980301,243286,64642,167740,91332,271685,16931,752681,612608,869872,493611,263322,386115,203300,416956,386198,894359,894599,143820,258909,352358,1031992,588175,999763,44875,558137,432945,714089,510419,387881,1040670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]