SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438072 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438072 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232005,290188,1010080,162031,472365,56666,477898,937948,603653,980966,785605,779660,339283,529438,78716,439495,142818,192973,142779,869351,480015,591623,148876,575220,551883,697334,241374,122471,270841,26852,523703,255682,998578,667430,279940,519808,317017,233491,1044136,980428,314402,108859,368796,479266,120540,91180,387347,177285,346461,432828,1047442,996966,2035,430428,890238,650870,503734,452854,179729,483714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]