SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102310 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102310 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919586,588850,892020,1013078,1040583,200490,299907,51801,312899,155183,356427,415748,752063,42180,140630,472481,329047,334776,593518,479075,343145,780397,157222,32238,917371,458112,753315,385369,963071,379106,746100,755565,418713,247929,130802,968860,1027380,214073,753319,459361,12412,937466,771930,804050,775063,392219,474585,294402,630057,689714,172748,833185,141391,842608,611184,564873,735509,32858,700876,275153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]