SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502382 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502382 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382402,538692,1011074,137612,817884,870472,529694,259383,521218,535399,675127,191196,676565,146673,173163,28637,781526,954511,667971,768575,207286,958926,78411,702290,488234,438999,811983,956433,866179,735155,49628,919898,782627,682735,802376,196614,404695,439064,120834,318364,573183,641938,837006,844956,965197,352297,326135,1023330,892130,355780,521111,474062,1010694,314914,182669,485132,799721,204712,579895,590577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]