SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503884 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503884 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55111,770718,265653,345679,222249,938022,865560,580016,724187,76519,901579,582658,286880,55592,3346,883320,175335,880840,604242,42382,650894,588204,121793,223879,426749,1029129,825146,584583,474358,264202,979698,651940,662736,145186,80881,414961,211374,82411,445321,162959,964922,72084,178042,823189,351541,230907,967843,935841,18786,239951,430314,304544,356595,117484,64450,342799,674016,16866,13608,399368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]