SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486033 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486033 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863080,483735,404290,891922,1013161,55996,103006,258001,488850,501121,479485,671896,838838,356523,718777,862191,710853,763633,637973,103141,49431,39489,927562,477374,525930,431055,754414,110274,46752,633398,793549,747680,100403,748041,54687,394962,171433,527590,808444,835202,146893,464311,356375,790578,548710,426455,40613,168594,533957,700284,183998,442244,968009,235464,642634,543271,114480,529535,408217,387398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]