SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549313 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549313 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394947,428688,378492,532630,412951,935640,750762,632946,61473,203854,125363,105155,223495,426145,468205,1048384,959638,295533,990488,360532,706055,955992,212301,591826,539403,988412,139481,625576,709820,712241,471534,495685,858041,291486,588412,100073,39605,16449,445881,212169,267805,345988,968238,70176,976456,886492,769161,260308,966767,293185,498467,26087,995955,748313,304495,87395,297350,818290,951868,46712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]