SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038049 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038049 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591725,662565,477245,709171,46563,667821,88474,885879,565277,994938,882992,363565,485994,171605,370482,902918,582758,949799,72711,862745,608956,870246,964548,219466,587064,4997,928953,765445,450463,157970,480817,644792,642767,195886,439116,440670,3464,466270,956545,999732,899112,158172,559921,513192,122262,922019,490821,149067,84340,721798,1015688,662199,166900,771235,9457,336368,236245,475385,114915,1008067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]