SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432186 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432186 [ RunTime:0.002514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905039,232518,81181,369434,453150,337480,254335,880963,490947,414014,288584,647516,1030756,403021,804551,700629,285257,627718,160678,798893,570666,642536,807492,60568,875248,515358,357741,243586,20191,188468,72358,1014618,66764,573818,550781,956357,57724,769625,644527,255325,342374,48854,339841,469120,53010,750891,910938,438208,373293,756605,549757,499512,395395,507355,634609,30755,365928,619432,957889,528875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]