SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385310 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385310 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559165,733238,494949,571339,307589,760409,264940,289277,584537,400928,408755,712193,402081,438898,363831,267696,455092,604561,562466,990251,858267,933329,334729,359133,936477,178388,828740,72050,968650,842721,967713,800679,707300,571696,210426,501457,971952,662577,580348,1026992,173487,78453,35661,515966,385690,544926,135029,430377,76403,811388,828199,991915,485233,561134,369951,53398,286071,890903,1016102,254420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006318s ]