SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106194 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106194 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864534,621453,598525,398381,836974,714178,54695,281873,580989,158916,314919,357606,656630,321885,7700,45436,425354,478114,959454,764196,836618,419492,1003838,391137,584946,280191,834483,731374,1019417,202327,1037554,278404,1035462,79309,900163,368905,1005331,529603,156591,506993,189011,726834,252341,254599,330302,817184,816191,994137,201346,307164,243264,349496,324868,632746,1000619,514654,876798,520436,196790,557804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001195s ]