SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404139 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404139 [ RunTime:0.004063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430427,762603,29422,322324,175112,379608,455604,442229,194553,34622,483775,365935,13654,8130,319138,860568,666444,547770,752721,990496,833781,994607,200776,694825,867382,815700,533443,194673,726917,630951,749786,600835,106790,858613,197040,39151,167330,719613,818353,370753,498037,411500,599626,968127,777027,389351,968583,259216,840866,512635,286526,1010909,290083,18433,752848,911739,486868,901224,865859,175500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]